package com.hz.ruoyistorage.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.hz.ruoyistorage.domain.mypojo.LgSubColdSome;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
 * @version 1.0
 * @Author gj
 * @Date 2025/3/6 9:53
 * @注释
 */
public interface LgSubColdSomeMapper extends BaseMapper<LgSubColdSome> {
//    @Select("SELECT a.sub_id, a.parent_id, b.cold_name, a.sub_name, a.description, a.capacity, a.daily_price, a.cold_id, d.type_name, a.manager_id, c.user_name" +
//            ",a.`status`,a.current_owner,a.create_by,a.update_by,a.create_time,a.update_time,a.delete_status " +
//            "FROM lg_sub_cold AS a " +
//            "LEFT JOIN lg_cold_storage AS b ON a.parent_id = b.cold_id " +
//            "LEFT JOIN sys_user AS c ON a.manager_id = c.user_id " +
//            "LEFT JOIN lg_cold_type AS d ON a.cold_id = d.cold_type_id")
    public List<LgSubColdSome> getAll(Map<String, Object> some);
    public Integer getTotal(Map<String, Object> some);

    public List<LgSubColdSome> getSubAndCamera(Map<String, Object> some);


    public List<LgSubColdSome> getSubAndMachine(Map<String, Object> some);
}
